A New Way to Implement Database Replication
نویسندگان
چکیده
Database designers often point out that eager, update everywhere replication suuers from high deadlock rates, message overhead and poor response times. In this paper, we show that these limitations can be circumvented by using a combination of known and novel techniques. Moreover, we show how the proposed solution can be incorporated into a real database system. The paper discusses the new protocols and their implementation in Post-greSQL. It also provides experimental results proving that many of the dangers and limitations of replication can be avoided by using the appropriate techniques.
منابع مشابه
Group Communications and Database Replication: techniques, issues and performance
Databases are an important part of today’s IT infrastructure: both companies and state institutions rely on database systems to store most of their important data. As we are more and more dependent on database systems, securing this key facility is now a priority. Because of this, research on fault-tolerant database systems is of increasing importance. One way to ensure the fault-tolerance of a...
متن کاملBeyond 1-Safety and 2-Safety for Replicated Databases: Group-Safety
In this paper, we study the safety guarantees of group communicationbased database replication techniques. We show that there is a model mismatch between group communication and database, and because of this, classical group communication systems cannot be used to build 2-safe database replication. We propose a new group communication primitive called end-to-end atomic broadcast that solves the...
متن کاملمسیریابی مبتنی بر زمان در کتابخانه مرکز اطلاعات و مدارک علمی کشاورزی
Nowadays, Geographic Information Systems applications enter in libraries and information centers and some advanced libraries in the world use the benefits of GIS in general to improve the space and resources. The present study aimed to implement a way finding system in order to facilitate the users’ access to the facilities and services in the library of the Agriculture Information and Scientif...
متن کاملConflict-Aware Scheduling for Dynamic Content Applications
We present a new lazy replication technique, suitable for scaling the back-end database of a dynamic content site using a cluster of commodity computers. Our technique, called conflict-aware scheduling, provides both throughput scaling and 1-copy serializability. It has generally been believed that this combination is hard to achieve through replication because of the growth of the number of co...
متن کامل